package com.witte.service;

import java.util.List;

import com.witte.entity.CusNOrdProN;
import com.witte.entity.Offer;
import com.witte.entity.Orders;
import com.witte.entity.Statitic;

public interface OrdersService {
	//return all orders from table 'Orders'
	List<Orders> getAllOrders();
	
	//return all orders in 'paid' state.
	int getSumMoney();
	
	//return all customers name ,money,product name
	List<CusNOrdProN> getAllCOP();
	
	//return all orders(product name , money, state ,customer name) by customer name
	List<CusNOrdProN> getCOPByCusName(String name);
	
	//return order by no
	Orders getOrderByNo();

	public List<Orders> selectForPage(Integer beginPage, Integer pageSize);
	public int getCount();

	List<Integer> getAllLost();
}
